/*
 Navicat Premium Data Transfer

 Source Server         : 10.200.9.224.show.mysql
 Source Server Type    : MySQL
 Source Server Version : 80016
 Source Host           : 10.200.9.224:3306
 Source Schema         : demo_user

 Target Server Type    : MySQL
 Target Server Version : 80016
 File Encoding         : 65001

 Date: 02/02/2021 10:10:18
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for dic_user_type
-- ----------------------------
DROP TABLE IF EXISTS `dic_user_type`;
CREATE TABLE `dic_user_type` (
  `code` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of dic_user_type
-- ----------------------------
BEGIN;
INSERT INTO `dic_user_type` VALUES ('use_type_001', '2021-01-28 20:38:15', '学生');
INSERT INTO `dic_user_type` VALUES ('use_type_002', '2021-01-28 20:38:15', '老师');
INSERT INTO `dic_user_type` VALUES ('use_type_003', '2021-01-28 20:38:15', '后台管理员');
INSERT INTO `dic_user_type` VALUES ('use_type_004', '2021-01-28 20:38:15', '财务');
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `mobile` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `user_type` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `school_id` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '所在学校',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES ('091cb8ededd86ae6a6b127729378fc71', '2021-01-28 20:53:45', '张三', 'zhangsan@qq.com', '15112347896', 'use_type_001', '9437f68f2b762c98e19f5e35c3819e53');
INSERT INTO `user` VALUES ('fc271fd479799eda9478982cd884df65', '2021-01-28 20:53:45', '李四', 'lisi@qq.com', '15812345678', 'use_type_002,use_type_003', '8b7c66129a85e4cdfed21f32fab9eab2');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
